Understanding How Metadata and Explanations Can Better Support Data Warehousing and Related Decision Support Systems: An Exploratory Case Study

Many businesses have made or are making significant investments in data warehouses and marts that are designed to support a myriad of decision support systems (DSS). Due to the newness of data warehousing and related DSS (DWDSS), the nature of the decision support provided to DSS users and the importance of metadata and explanations within that support have not been documented. An exploratory case study has been undertaken at two organizations that are using data warehouses to support a particular type of DW-DSS, CRM systems. CRM systems were selected as a representative DW-DSS due to the large-number of system users and the various types of DSS tools that these systems typically encompass. The DSS-decision performance model suggested by Todd and Benbasat has been employed as a framework for this exploration. Constructs from Gregor and Benbasat’s meta-analysis of explanation use were used to guide the investigation of the explanations.